package com.xdf.xzymanagementsystem.dao;

import com.mybatisflex.core.BaseMapper;
import com.xdf.xzymanagementsystem.entity.Payment;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * @Description : 由代码生成器生成
 * @Author : chanchaw
 * @Date :  2025-3-22 10:27:04
 */
@Repository
public interface PaymentMapper extends BaseMapper<Payment> {
    //=================以上是自动生成的代码，自定义代码请写在下面==================

    //白坯应付款 - 报表数据
    @Select("CALL usp_grey_meet(#{start},#{end},#{clientName},#{value})")
    List<Map<String, Object>> selectGreyMeet(Date start, Date end, String clientName, Integer value);

    //染厂应付款 - 报表数据
    @Select("CALL usp_dyeing_meet(#{start},#{end},#{clientName},#{value})")
    List<Map<String, Object>> selectDyeingMeet(Date start, Date end, String clientName, Integer value);

    //深加工应付款 - 报表数据
    @Select("CALL usp_deep_meet(#{start},#{end},#{clientName},#{value})")
    List<Map<String, Object>> selectDeepMeet(Date start, Date end, String clientName, Integer value);

    //成品应收款 - 报表数据
    @Select("CALL usp_client_collect(#{start},#{end},#{clientName},#{value})")
    List<Map<String, Object>> selectClientCollect(Date start, Date end, String clientName, Integer value);
}